StillExecuting Property (Remote Data)

       

Returns a Boolean value that indicates whether a query is still executing.

Syntax

object.StillExecuting

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The StillExecuting property return values are:

Value Description
True The query is still executing.
False The query is ready to return the result set.

Remarks

Use the StillExecuting property to determine if a query is ready to return the first result set. Until the StillExecuting property is False, the associated object cannot be accessed. However, unless you use the rdAsyncEnable option, your application will block until the query is completed and ready to process the result set.

Once the StillExecuting property returns False, the first or next result set is ready for processing. When you use the MoreResults method to complete processing of a result set, the StillExecuting property is reset to True while the next result sets is retrieved.

The StillExecuting property also changes to True when you execute a Move method. For example executing MoveLast against an rdoResultset resets the StillExecuting property to True as long as RDO continues to fetch rows from the remote server.

You can also use the QueryComplete event to indicate when a query has completed and the associated rdoResultset object is ready to process.

Use the Cancel method to terminate processing of an executing query, including all statements in a batch query.